SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[usp_SearchParticipants_applyByID]

	(
	@param_id int 
	

	)

AS
	/* SET NOCOUNT ON */
	
	
	SELECT  recruitment,
			topic,
			dbo.JOL_Recruitment_Participants_apply.add_time ,
	        booth_arrange ,
	        booth_quantity ,
	        contactperson ,
	        email ,
	        employing_unit,
	        JOL_Employer_Name ,
	        fax ,
	        invoice_beginning ,
	        invoice_item ,
	        is_need_invoice ,
	        is_payment ,
	        mobile ,
	        is_visible ,
	        phone ,
	        remark_invoice ,
	        remark_recruitment ,
	        dbo.JOL_Recruitment_Participants_apply.state ,
	        dbo.JOL_Recruitment_Participants_apply.update_time ,
	        dbo.JOL_Recruitment_Participants_apply.user_add ,
	        user_check ,
	        dbo.JOL_Recruitment_Participants_apply.user_update
	        from dbo.JOL_Recruitment,dbo.JOL_Recruitment_Participants_apply,dbo.JOL_Employer
	        WHERE dbo.JOL_Recruitment_Participants_apply.id= @param_id AND recruitment=dbo.JOL_Recruitment.id AND employing_unit=JOL_Employer_No
	 
	RETURN
GO
